leetcode-sql/medium/1341. Movie Rating.sql at main · cM2908/leetcode-sql · GitHub

Name: leetcode-sql/medium/1341. Movie Rating.sql at main · cM2908/leetcode-sql · GitHub
Rating: 4.9 (9658 reviews)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
(SELECTu.name
FROM movie_rating_1341 mr
INNER JOIN users_1341 u ONmr.user_id=u.user_id
GROUP BYu.name
ORDER BYCOUNT(mr.rating) DESC,u.name
LIMIT1)
UNION
(SELECTm.title
FROM movie_rating_1341 mr
INNER JOIN movies_1341 m ONmr.movie_id=m.movie_id
WHERE EXTRACT(MONTH FROM created_at)=2
GROUP BYm.title
ORDER BYAVG(mr.rating) DESC,m.title
LIMIT1);